﻿Public Class TimKiemSP_DAO
    Public Shared Function selectByTenSP(_sp As TimKiemSP_DTO) As DataTable
        Dim sp As DataTable
        Dim strSQL As String = "select *from SanPham where TenSanPham like '%" & _sp.sanpham & "%'"
        sp = SQLProvider.ExecQuery(strSQL)
        Return sp

    End Function
    Public Shared Function selectByMaSP(_sp As TimKiemSP_DTO) As DataTable
        Dim sp As DataTable
        Dim strSQL As String = "select *from SanPham where MaSanPham like '%" & _sp.sanpham & "%'"
        sp = SQLProvider.ExecQuery(strSQL)
        Return sp

    End Function
End Class
